Access Level 1

Course Description

Students will learn the skills necessary to begin using Access, including designing and creating databases, tables, queries, forms, and reports.

Course Content

Unit 1: Getting Started
Database concepts
Exploring the Access environment

Unit 2: Databases and tables
Planning and designing databases
Exploring tables
Creating tables

Unit 3: Fields and records
Changing the design of a table
Finding and editing records
Organizing records

Unit 4: Data entry rules
Setting field properties
Working with input masks
Setting validation rules

Unit 5: Basic queries
Creating and using queries
Modifying query results and queries
Performing operations in queries

Unit 6: Using forms
Creating forms
Using Design view
Sorting and filtering records

Unit 7:Working with reports
Creating reports
Modifying and printing reports


pdf Printable course details

Prerequisites

Computers for Beginners

or equivalent knowledge.

Course Duration

7.5 hours

Study Methods Available

Individual Tuition

Group Training

Distance Learning


Prices

Distance Learning price
  £85  
  Paypal logo  

For other prices, please contact us.

Follow-on Courses

Access Level 2

All Courses

Click here to see all our courses.

Further Information

Enquiry Form

OCR
  Cisco

Sage

CompTIA logo

   BCS logo
ECDL logo
 MCP logo

     Adobe logo